{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 日期处理\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-18T09:10:38.958516Z",
     "start_time": "2019-07-18T09:10:37.897323Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>MOBILE_NO</th>\n",
       "      <th>ACCOUNT_ID</th>\n",
       "      <th>CUSTOMER_NAME</th>\n",
       "      <th>REQUEST_DATE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>GRANT_AMOUNT</th>\n",
       "      <th>FAIL_REASON</th>\n",
       "      <th>ACTIVE_START_DATE</th>\n",
       "      <th>EDUCATION_DEGREE</th>\n",
       "      <th>...</th>\n",
       "      <th>二手单</th>\n",
       "      <th>D_MONTHLY_SALARY</th>\n",
       "      <th>IS_MARRIED</th>\n",
       "      <th>EDUCATIONDEGREE</th>\n",
       "      <th>INDUSTRY_CATEGORY</th>\n",
       "      <th>CSP</th>\n",
       "      <th>GRADUATION_DATE</th>\n",
       "      <th>D_DEBIT_BANK_NAME</th>\n",
       "      <th>EMERGANCY_FIRST_RELATIONSHIP</th>\n",
       "      <th>EMERGANCY_SECOND_RELATIONSHIP</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>804</td>\n",
       "      <td>18626057156</td>\n",
       "      <td>20190501203459185716</td>\n",
       "      <td>贾从义</td>\n",
       "      <td>2019/5/1 20:34:59</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>同盾智查分不符合最小值</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1982.0</td>\n",
       "      <td>江阴农商银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>14311</td>\n",
       "      <td>13320331219</td>\n",
       "      <td>20190511110715614265</td>\n",
       "      <td>曾海宁</td>\n",
       "      <td>2019/5/11 11:07:15</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/11</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7918</td>\n",
       "      <td>13923743324</td>\n",
       "      <td>20190514162657752351</td>\n",
       "      <td>龚秀琼</td>\n",
       "      <td>2019/5/14 16:26:58</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>234000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/14</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>24042</td>\n",
       "      <td>18083038000</td>\n",
       "      <td>20190514121709737679</td>\n",
       "      <td>阳莉</td>\n",
       "      <td>2019/5/14 12:17:09</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>384000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/14</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4886</td>\n",
       "      <td>18996077331</td>\n",
       "      <td>20190618184444519244</td>\n",
       "      <td>陈健</td>\n",
       "      <td>2019/6/18 18:44:45</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>命中重庆专属策略</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>平安银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6011</td>\n",
       "      <td>18115700800</td>\n",
       "      <td>20190623100304707564</td>\n",
       "      <td>孙菲菲</td>\n",
       "      <td>2019/6/23 10:03:04</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/23</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>中国银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>17560</td>\n",
       "      <td>18046981889</td>\n",
       "      <td>20190508160627504224</td>\n",
       "      <td>易镜明</td>\n",
       "      <td>2019/5/8 16:06:27</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>288000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/8</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>19062</td>\n",
       "      <td>18961510333</td>\n",
       "      <td>20190510145023582816</td>\n",
       "      <td>陈书友</td>\n",
       "      <td>2019/5/10 14:50:24</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>入网时长为空，三月消费金额为空</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>邮储银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>28208</td>\n",
       "      <td>18002891155</td>\n",
       "      <td>20190421151011594612</td>\n",
       "      <td>陶容</td>\n",
       "      <td>2019/4/21 15:10:12</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/4/21</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>中国工商银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10437</td>\n",
       "      <td>18896574515</td>\n",
       "      <td>20190327192927506256</td>\n",
       "      <td>黄双琼</td>\n",
       "      <td>2019/3/27 19:29:28</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>198000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/3/27</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>中国工商银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>12521</td>\n",
       "      <td>18352535523</td>\n",
       "      <td>20190609110121117394</td>\n",
       "      <td>蒋友菊</td>\n",
       "      <td>2019/6/9 11:01:22</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>180000.0</td>\n",
       "      <td>人脸服务调用异常</td>\n",
       "      <td>2019/6/9</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>邮储银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>9064</td>\n",
       "      <td>18675115834</td>\n",
       "      <td>20190425220838766900</td>\n",
       "      <td>蒙仁叉</td>\n",
       "      <td>2019/4/25 22:08:38</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>年龄不匹配</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>中国邮政储蓄银行</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2597</td>\n",
       "      <td>17823165522</td>\n",
       "      <td>20190530092422601696</td>\n",
       "      <td>唐秀苹</td>\n",
       "      <td>2019/5/30 9:24:22</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>180000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/30</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>邮储银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>80</td>\n",
       "      <td>18251563579</td>\n",
       "      <td>20190409095415983977</td>\n",
       "      <td>王兴俊</td>\n",
       "      <td>2019/4/9 9:54:15</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>同盾智查分不符合最小值</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>中国银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>26388</td>\n",
       "      <td>19952777781</td>\n",
       "      <td>20190520144630151297</td>\n",
       "      <td>冯良东</td>\n",
       "      <td>2019/5/20 14:46:30</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>入网时长为空，自营分小于600或者三月消费小于100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>11576</td>\n",
       "      <td>19952343035</td>\n",
       "      <td>20190614184925358790</td>\n",
       "      <td>张永刚</td>\n",
       "      <td>2019/6/14 18:49:25</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>入网时长为空，三月消费金额为空</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>12632</td>\n",
       "      <td>13585051426</td>\n",
       "      <td>20190501203926185907</td>\n",
       "      <td>李鹏飞</td>\n",
       "      <td>2019/5/1 20:39:26</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>工商银行</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>16543</td>\n",
       "      <td>18012351044</td>\n",
       "      <td>20190509163302548124</td>\n",
       "      <td>李潮兵</td>\n",
       "      <td>2019/5/9 16:33:02</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/9</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>12118</td>\n",
       "      <td>18121647398</td>\n",
       "      <td>20190619195226559786</td>\n",
       "      <td>尤龙宝</td>\n",
       "      <td>2019/6/19 19:52:26</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>入网时长为空，自营分小于600或者三月消费小于100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>中国银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>6775</td>\n",
       "      <td>13771524971</td>\n",
       "      <td>20190520105122133056</td>\n",
       "      <td>张峰</td>\n",
       "      <td>2019/5/20 10:51:22</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/20</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1987.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>26977</td>\n",
       "      <td>13851864069</td>\n",
       "      <td>20190616105401414296</td>\n",
       "      <td>徐坚</td>\n",
       "      <td>2019/6/16 10:54:01</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/16</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>邮储银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>287</td>\n",
       "      <td>18752356829</td>\n",
       "      <td>20190410141624132068</td>\n",
       "      <td>赵培强</td>\n",
       "      <td>2019/4/10 14:16:25</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>420000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/4/10</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>8206</td>\n",
       "      <td>19984963035</td>\n",
       "      <td>20190614193238360521</td>\n",
       "      <td>张敏</td>\n",
       "      <td>2019/6/14 19:32:38</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>交通银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>16079</td>\n",
       "      <td>18068342325</td>\n",
       "      <td>20190418124627455129</td>\n",
       "      <td>陈华业</td>\n",
       "      <td>2019/4/18 12:46:27</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>144000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/4/18</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>中国银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>6562</td>\n",
       "      <td>13951537208</td>\n",
       "      <td>20190517234212915353</td>\n",
       "      <td>李娟</td>\n",
       "      <td>2019/5/17 23:42:13</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>198000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/17</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>10910</td>\n",
       "      <td>13771285397</td>\n",
       "      <td>20190422200612648717</td>\n",
       "      <td>冯成香</td>\n",
       "      <td>2019/4/22 20:06:12</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/4/22</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>交通银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>3923</td>\n",
       "      <td>18861715265</td>\n",
       "      <td>20190528175934543827</td>\n",
       "      <td>徐晓梅</td>\n",
       "      <td>2019/5/28 17:59:34</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>300000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/28</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1989.0</td>\n",
       "      <td>工商银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>5573</td>\n",
       "      <td>18015186618</td>\n",
       "      <td>20190419095259484656</td>\n",
       "      <td>唐为平</td>\n",
       "      <td>2019/4/19 9:52:59</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/4/19</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>3580</td>\n",
       "      <td>15852621963</td>\n",
       "      <td>20190601103817696709</td>\n",
       "      <td>潘春梅</td>\n",
       "      <td>2019/6/1 10:38:17</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>同盾智查分不符合最小值</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>17708</td>\n",
       "      <td>18015185727</td>\n",
       "      <td>20190419170538515068</td>\n",
       "      <td>杨贵宣</td>\n",
       "      <td>2019/4/19 17:05:39</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>288000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/4/19</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27440</th>\n",
       "      <td>21086</td>\n",
       "      <td>13590738653</td>\n",
       "      <td>20190605103134845665</td>\n",
       "      <td>肖志友</td>\n",
       "      <td>2019/6/5 10:31:34</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>330000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/5</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>工商银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27441</th>\n",
       "      <td>28604</td>\n",
       "      <td>18925778949</td>\n",
       "      <td>20190605124645853394</td>\n",
       "      <td>谢小芳</td>\n",
       "      <td>2019/6/5 12:46:45</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>工商银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27442</th>\n",
       "      <td>7529</td>\n",
       "      <td>18925393759</td>\n",
       "      <td>20190416094733364714</td>\n",
       "      <td>郭生军</td>\n",
       "      <td>2019/4/16 9:47:33</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>460800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/4/16</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27443</th>\n",
       "      <td>21886</td>\n",
       "      <td>13798754711</td>\n",
       "      <td>20190528134949524566</td>\n",
       "      <td>郑萌</td>\n",
       "      <td>2019/5/28 13:49:49</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/28</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27444</th>\n",
       "      <td>19678</td>\n",
       "      <td>13392389094</td>\n",
       "      <td>20190518150034947591</td>\n",
       "      <td>郑湘连</td>\n",
       "      <td>2019/5/18 15:00:34</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>460800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/18</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27445</th>\n",
       "      <td>13422</td>\n",
       "      <td>18576014599</td>\n",
       "      <td>20190618203548522638</td>\n",
       "      <td>段小军</td>\n",
       "      <td>2019/6/18 20:35:48</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>384000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/18</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27446</th>\n",
       "      <td>18238</td>\n",
       "      <td>18022064640</td>\n",
       "      <td>20190624105125761198</td>\n",
       "      <td>钟小荣</td>\n",
       "      <td>2019/6/24 10:51:25</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/24</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>工商银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27447</th>\n",
       "      <td>8117</td>\n",
       "      <td>18938288301</td>\n",
       "      <td>20190509151637542161</td>\n",
       "      <td>龙圣麒</td>\n",
       "      <td>2019/5/9 15:16:38</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>460800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/9</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2003.0</td>\n",
       "      <td>中国银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27448</th>\n",
       "      <td>12537</td>\n",
       "      <td>17328199871</td>\n",
       "      <td>20190514160111750371</td>\n",
       "      <td>梁亮</td>\n",
       "      <td>2019/5/14 16:01:11</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/14</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27449</th>\n",
       "      <td>8769</td>\n",
       "      <td>15976691672</td>\n",
       "      <td>20190623200518751592</td>\n",
       "      <td>郑勇军</td>\n",
       "      <td>2019/6/23 20:05:18</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/23</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>邮储银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27450</th>\n",
       "      <td>2437</td>\n",
       "      <td>15800169257</td>\n",
       "      <td>20190523213541339203</td>\n",
       "      <td>周丽丽</td>\n",
       "      <td>2019/5/23 21:35:41</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>180000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/23</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>工商银行</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27451</th>\n",
       "      <td>28317</td>\n",
       "      <td>18928175909</td>\n",
       "      <td>20190526155050454458</td>\n",
       "      <td>唐健</td>\n",
       "      <td>2019/5/26 15:50:50</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>入网时长为空，自营分小于600或者三月消费小于100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27452</th>\n",
       "      <td>28358</td>\n",
       "      <td>15502084190</td>\n",
       "      <td>20190505160953387840</td>\n",
       "      <td>邓娟娟</td>\n",
       "      <td>2019/5/5 16:09:53</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>144000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/5</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>工商银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27453</th>\n",
       "      <td>11490</td>\n",
       "      <td>13318277798</td>\n",
       "      <td>20190619134015539711</td>\n",
       "      <td>何瑞英</td>\n",
       "      <td>2019/6/19 13:40:16</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>384000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/19</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27454</th>\n",
       "      <td>18342</td>\n",
       "      <td>13875694639</td>\n",
       "      <td>20190504165422348270</td>\n",
       "      <td>曾三仔</td>\n",
       "      <td>2019/5/4 16:54:22</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>人脸服务调用异常</td>\n",
       "      <td>2019/5/4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27455</th>\n",
       "      <td>14412</td>\n",
       "      <td>13328152187</td>\n",
       "      <td>20190503173450299900</td>\n",
       "      <td>谢欢亮</td>\n",
       "      <td>2019/5/3 17:34:50</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27456</th>\n",
       "      <td>23749</td>\n",
       "      <td>15899795323</td>\n",
       "      <td>20190617112440455798</td>\n",
       "      <td>李向英</td>\n",
       "      <td>2019/6/17 11:24:41</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/17</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27457</th>\n",
       "      <td>7906</td>\n",
       "      <td>18924947774</td>\n",
       "      <td>20190607170451955009</td>\n",
       "      <td>晋利那</td>\n",
       "      <td>2019/6/7 17:04:52</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>499200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/7</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>工商银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27458</th>\n",
       "      <td>21558</td>\n",
       "      <td>15370120063</td>\n",
       "      <td>20190321161642252207</td>\n",
       "      <td>杜晓辉</td>\n",
       "      <td>2019/3/21 16:16:42</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>105600.0</td>\n",
       "      <td>请求次数过多</td>\n",
       "      <td>2019/3/21</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>中国农业银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27459</th>\n",
       "      <td>11787</td>\n",
       "      <td>13798754996</td>\n",
       "      <td>20190607203106963475</td>\n",
       "      <td>何红霞</td>\n",
       "      <td>2019/6/7 20:31:06</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>180000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/7</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1995.0</td>\n",
       "      <td>招商银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27460</th>\n",
       "      <td>21865</td>\n",
       "      <td>13592069463</td>\n",
       "      <td>20190416174843395249</td>\n",
       "      <td>万小辉</td>\n",
       "      <td>2019/4/16 17:48:43</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>命中百融黑名单</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>中国农业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27461</th>\n",
       "      <td>28669</td>\n",
       "      <td>15038608931</td>\n",
       "      <td>20190501210846186843</td>\n",
       "      <td>许涛涛</td>\n",
       "      <td>2019/5/1 21:08:46</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>同盾智查分不符合最小值</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27462</th>\n",
       "      <td>19532</td>\n",
       "      <td>15099792368</td>\n",
       "      <td>20190425134918743906</td>\n",
       "      <td>郝卫宾</td>\n",
       "      <td>2019/4/25 13:49:18</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>330000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/4/25</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1989.0</td>\n",
       "      <td>中国农业银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27463</th>\n",
       "      <td>28537</td>\n",
       "      <td>17712061228</td>\n",
       "      <td>20190622162933686835</td>\n",
       "      <td>樊华敏</td>\n",
       "      <td>2019/6/22 16:29:38</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>369600.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/22</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>中国银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27464</th>\n",
       "      <td>13545</td>\n",
       "      <td>18933541668</td>\n",
       "      <td>20190613150528305329</td>\n",
       "      <td>吴跃斌</td>\n",
       "      <td>2019/6/13 15:05:28</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>100800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/13</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27465</th>\n",
       "      <td>26311</td>\n",
       "      <td>18925455182</td>\n",
       "      <td>20190519181640118989</td>\n",
       "      <td>孟良元</td>\n",
       "      <td>2019/5/19 18:16:41</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>264000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/19</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27466</th>\n",
       "      <td>14825</td>\n",
       "      <td>18925793007</td>\n",
       "      <td>20190503161041292132</td>\n",
       "      <td>韦广林</td>\n",
       "      <td>2019/5/3 16:10:41</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>240000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/5/3</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1986.0</td>\n",
       "      <td>中国邮政储蓄银行</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27467</th>\n",
       "      <td>26760</td>\n",
       "      <td>18046980778</td>\n",
       "      <td>20190601180230723988</td>\n",
       "      <td>孟秀海</td>\n",
       "      <td>2019/6/1 18:02:30</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>336000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>东莞农村商业银行</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27468</th>\n",
       "      <td>18564</td>\n",
       "      <td>18885427791</td>\n",
       "      <td>20190619144803543431</td>\n",
       "      <td>蒙永志</td>\n",
       "      <td>2019/6/19 14:48:03</td>\n",
       "      <td>SUCCESS</td>\n",
       "      <td>180000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/6/19</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>1988.0</td>\n",
       "      <td>中国银行</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27469</th>\n",
       "      <td>24065</td>\n",
       "      <td>18114112182</td>\n",
       "      <td>20190401134012707769</td>\n",
       "      <td>韦兴海</td>\n",
       "      <td>2019/4/1 13:40:12</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>自营分不符合最小值</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>中国电信</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>中国农业银行</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27470 rows × 86 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0    MOBILE_NO            ACCOUNT_ID CUSTOMER_NAME  \\\n",
       "0             804  18626057156  20190501203459185716           贾从义   \n",
       "1           14311  13320331219  20190511110715614265           曾海宁   \n",
       "2            7918  13923743324  20190514162657752351           龚秀琼   \n",
       "3           24042  18083038000  20190514121709737679            阳莉   \n",
       "4            4886  18996077331  20190618184444519244            陈健   \n",
       "5            6011  18115700800  20190623100304707564           孙菲菲   \n",
       "6           17560  18046981889  20190508160627504224           易镜明   \n",
       "7           19062  18961510333  20190510145023582816           陈书友   \n",
       "8           28208  18002891155  20190421151011594612            陶容   \n",
       "9           10437  18896574515  20190327192927506256           黄双琼   \n",
       "10          12521  18352535523  20190609110121117394           蒋友菊   \n",
       "11           9064  18675115834  20190425220838766900           蒙仁叉   \n",
       "12           2597  17823165522  20190530092422601696           唐秀苹   \n",
       "13             80  18251563579  20190409095415983977           王兴俊   \n",
       "14          26388  19952777781  20190520144630151297           冯良东   \n",
       "15          11576  19952343035  20190614184925358790           张永刚   \n",
       "16          12632  13585051426  20190501203926185907           李鹏飞   \n",
       "17          16543  18012351044  20190509163302548124           李潮兵   \n",
       "18          12118  18121647398  20190619195226559786           尤龙宝   \n",
       "19           6775  13771524971  20190520105122133056            张峰   \n",
       "20          26977  13851864069  20190616105401414296            徐坚   \n",
       "21            287  18752356829  20190410141624132068           赵培强   \n",
       "22           8206  19984963035  20190614193238360521            张敏   \n",
       "23          16079  18068342325  20190418124627455129           陈华业   \n",
       "24           6562  13951537208  20190517234212915353            李娟   \n",
       "25          10910  13771285397  20190422200612648717           冯成香   \n",
       "26           3923  18861715265  20190528175934543827           徐晓梅   \n",
       "27           5573  18015186618  20190419095259484656           唐为平   \n",
       "28           3580  15852621963  20190601103817696709           潘春梅   \n",
       "29          17708  18015185727  20190419170538515068           杨贵宣   \n",
       "...           ...          ...                   ...           ...   \n",
       "27440       21086  13590738653  20190605103134845665           肖志友   \n",
       "27441       28604  18925778949  20190605124645853394           谢小芳   \n",
       "27442        7529  18925393759  20190416094733364714           郭生军   \n",
       "27443       21886  13798754711  20190528134949524566            郑萌   \n",
       "27444       19678  13392389094  20190518150034947591           郑湘连   \n",
       "27445       13422  18576014599  20190618203548522638           段小军   \n",
       "27446       18238  18022064640  20190624105125761198           钟小荣   \n",
       "27447        8117  18938288301  20190509151637542161           龙圣麒   \n",
       "27448       12537  17328199871  20190514160111750371            梁亮   \n",
       "27449        8769  15976691672  20190623200518751592           郑勇军   \n",
       "27450        2437  15800169257  20190523213541339203           周丽丽   \n",
       "27451       28317  18928175909  20190526155050454458            唐健   \n",
       "27452       28358  15502084190  20190505160953387840           邓娟娟   \n",
       "27453       11490  13318277798  20190619134015539711           何瑞英   \n",
       "27454       18342  13875694639  20190504165422348270           曾三仔   \n",
       "27455       14412  13328152187  20190503173450299900           谢欢亮   \n",
       "27456       23749  15899795323  20190617112440455798           李向英   \n",
       "27457        7906  18924947774  20190607170451955009           晋利那   \n",
       "27458       21558  15370120063  20190321161642252207           杜晓辉   \n",
       "27459       11787  13798754996  20190607203106963475           何红霞   \n",
       "27460       21865  13592069463  20190416174843395249           万小辉   \n",
       "27461       28669  15038608931  20190501210846186843           许涛涛   \n",
       "27462       19532  15099792368  20190425134918743906           郝卫宾   \n",
       "27463       28537  17712061228  20190622162933686835           樊华敏   \n",
       "27464       13545  18933541668  20190613150528305329           吴跃斌   \n",
       "27465       26311  18925455182  20190519181640118989           孟良元   \n",
       "27466       14825  18925793007  20190503161041292132           韦广林   \n",
       "27467       26760  18046980778  20190601180230723988           孟秀海   \n",
       "27468       18564  18885427791  20190619144803543431           蒙永志   \n",
       "27469       24065  18114112182  20190401134012707769           韦兴海   \n",
       "\n",
       "             REQUEST_DATE   STATUS  GRANT_AMOUNT                 FAIL_REASON  \\\n",
       "0       2019/5/1 20:34:59     FAIL           NaN                 同盾智查分不符合最小值   \n",
       "1      2019/5/11 11:07:15  SUCCESS      500000.0                         NaN   \n",
       "2      2019/5/14 16:26:58  SUCCESS      234000.0                         NaN   \n",
       "3      2019/5/14 12:17:09  SUCCESS      384000.0                         NaN   \n",
       "4      2019/6/18 18:44:45     FAIL           NaN                    命中重庆专属策略   \n",
       "5      2019/6/23 10:03:04  SUCCESS      500000.0                         NaN   \n",
       "6       2019/5/8 16:06:27  SUCCESS      288000.0                         NaN   \n",
       "7      2019/5/10 14:50:24     FAIL           NaN             入网时长为空，三月消费金额为空   \n",
       "8      2019/4/21 15:10:12  SUCCESS      500000.0                         NaN   \n",
       "9      2019/3/27 19:29:28  SUCCESS      198000.0                         NaN   \n",
       "10      2019/6/9 11:01:22     FAIL      180000.0                    人脸服务调用异常   \n",
       "11     2019/4/25 22:08:38     FAIL           NaN                       年龄不匹配   \n",
       "12      2019/5/30 9:24:22  SUCCESS      180000.0                         NaN   \n",
       "13       2019/4/9 9:54:15     FAIL           NaN                 同盾智查分不符合最小值   \n",
       "14     2019/5/20 14:46:30     FAIL           NaN  入网时长为空，自营分小于600或者三月消费小于100   \n",
       "15     2019/6/14 18:49:25     FAIL           NaN             入网时长为空，三月消费金额为空   \n",
       "16      2019/5/1 20:39:26  SUCCESS      100000.0                         NaN   \n",
       "17      2019/5/9 16:33:02  SUCCESS      120000.0                         NaN   \n",
       "18     2019/6/19 19:52:26     FAIL           NaN  入网时长为空，自营分小于600或者三月消费小于100   \n",
       "19     2019/5/20 10:51:22  SUCCESS      100000.0                         NaN   \n",
       "20     2019/6/16 10:54:01  SUCCESS      500000.0                         NaN   \n",
       "21     2019/4/10 14:16:25  SUCCESS      420000.0                         NaN   \n",
       "22     2019/6/14 19:32:38     FAIL           NaN                   自营分不符合最小值   \n",
       "23     2019/4/18 12:46:27  SUCCESS      144000.0                         NaN   \n",
       "24     2019/5/17 23:42:13  SUCCESS      198000.0                         NaN   \n",
       "25     2019/4/22 20:06:12  SUCCESS      500000.0                         NaN   \n",
       "26     2019/5/28 17:59:34  SUCCESS      300000.0                         NaN   \n",
       "27      2019/4/19 9:52:59  SUCCESS      500000.0                         NaN   \n",
       "28      2019/6/1 10:38:17     FAIL           NaN                 同盾智查分不符合最小值   \n",
       "29     2019/4/19 17:05:39  SUCCESS      288000.0                         NaN   \n",
       "...                   ...      ...           ...                         ...   \n",
       "27440   2019/6/5 10:31:34  SUCCESS      330000.0                         NaN   \n",
       "27441   2019/6/5 12:46:45  SUCCESS      500000.0                         NaN   \n",
       "27442   2019/4/16 9:47:33  SUCCESS      460800.0                         NaN   \n",
       "27443  2019/5/28 13:49:49  SUCCESS      100000.0                         NaN   \n",
       "27444  2019/5/18 15:00:34  SUCCESS      460800.0                         NaN   \n",
       "27445  2019/6/18 20:35:48  SUCCESS      384000.0                         NaN   \n",
       "27446  2019/6/24 10:51:25  SUCCESS      500000.0                         NaN   \n",
       "27447   2019/5/9 15:16:38  SUCCESS      460800.0                         NaN   \n",
       "27448  2019/5/14 16:01:11  SUCCESS      120000.0                         NaN   \n",
       "27449  2019/6/23 20:05:18  SUCCESS      100000.0                         NaN   \n",
       "27450  2019/5/23 21:35:41  SUCCESS      180000.0                         NaN   \n",
       "27451  2019/5/26 15:50:50     FAIL           NaN  入网时长为空，自营分小于600或者三月消费小于100   \n",
       "27452   2019/5/5 16:09:53  SUCCESS      144000.0                         NaN   \n",
       "27453  2019/6/19 13:40:16  SUCCESS      384000.0                         NaN   \n",
       "27454   2019/5/4 16:54:22     FAIL      100000.0                    人脸服务调用异常   \n",
       "27455   2019/5/3 17:34:50  SUCCESS      100000.0                         NaN   \n",
       "27456  2019/6/17 11:24:41  SUCCESS      500000.0                         NaN   \n",
       "27457   2019/6/7 17:04:52  SUCCESS      499200.0                         NaN   \n",
       "27458  2019/3/21 16:16:42  SUCCESS      105600.0                      请求次数过多   \n",
       "27459   2019/6/7 20:31:06  SUCCESS      180000.0                         NaN   \n",
       "27460  2019/4/16 17:48:43     FAIL           NaN                     命中百融黑名单   \n",
       "27461   2019/5/1 21:08:46     FAIL           NaN                 同盾智查分不符合最小值   \n",
       "27462  2019/4/25 13:49:18  SUCCESS      330000.0                         NaN   \n",
       "27463  2019/6/22 16:29:38  SUCCESS      369600.0                         NaN   \n",
       "27464  2019/6/13 15:05:28  SUCCESS      100800.0                         NaN   \n",
       "27465  2019/5/19 18:16:41  SUCCESS      264000.0                         NaN   \n",
       "27466   2019/5/3 16:10:41  SUCCESS      240000.0                         NaN   \n",
       "27467   2019/6/1 18:02:30  SUCCESS      336000.0                         NaN   \n",
       "27468  2019/6/19 14:48:03  SUCCESS      180000.0                         NaN   \n",
       "27469   2019/4/1 13:40:12     FAIL           NaN                   自营分不符合最小值   \n",
       "\n",
       "      ACTIVE_START_DATE  EDUCATION_DEGREE  ...  二手单 D_MONTHLY_SALARY  \\\n",
       "0                   NaN                 1  ...  0.0              2.0   \n",
       "1             2019/5/11                 4  ...  0.0              2.0   \n",
       "2             2019/5/14                 1  ...  0.0              2.0   \n",
       "3             2019/5/14                 2  ...  0.0              3.0   \n",
       "4                   NaN                 3  ...  1.0              4.0   \n",
       "5             2019/6/23                 2  ...  0.0              2.0   \n",
       "6              2019/5/8                 2  ...  0.0              3.0   \n",
       "7                   NaN                 2  ...  1.0              2.0   \n",
       "8             2019/4/21                 2  ...  0.0              2.0   \n",
       "9             2019/3/27                 4  ...  0.0              2.0   \n",
       "10             2019/6/9                 1  ...  1.0              2.0   \n",
       "11                  NaN                 2  ...  0.0              2.0   \n",
       "12            2019/5/30                 2  ...  0.0              3.0   \n",
       "13                  NaN                 1  ...  1.0              2.0   \n",
       "14                  NaN                 2  ...  1.0              3.0   \n",
       "15                  NaN                 3  ...  1.0              3.0   \n",
       "16             2019/5/1                 1  ...  0.0              2.0   \n",
       "17             2019/5/9                 2  ...  1.0              2.0   \n",
       "18                  NaN                 2  ...  1.0              4.0   \n",
       "19            2019/5/20                 1  ...  0.0              2.0   \n",
       "20            2019/6/16                 1  ...  1.0              2.0   \n",
       "21            2019/4/10                 3  ...  0.0              3.0   \n",
       "22                  NaN                 3  ...  1.0              3.0   \n",
       "23            2019/4/18                 2  ...  0.0              2.0   \n",
       "24            2019/5/17                 1  ...  0.0              2.0   \n",
       "25            2019/4/22                 2  ...  0.0              2.0   \n",
       "26            2019/5/28                 2  ...  1.0              2.0   \n",
       "27            2019/4/19                 3  ...  0.0              3.0   \n",
       "28                  NaN                 1  ...  1.0              1.0   \n",
       "29            2019/4/19                 3  ...  0.0              2.0   \n",
       "...                 ...               ...  ...  ...              ...   \n",
       "27440          2019/6/5                 2  ...  0.0              2.0   \n",
       "27441          2019/6/5                 1  ...  0.0              2.0   \n",
       "27442         2019/4/16                 2  ...  0.0              3.0   \n",
       "27443         2019/5/28                 2  ...  0.0              2.0   \n",
       "27444         2019/5/18                 1  ...  0.0              2.0   \n",
       "27445         2019/6/18                 2  ...  0.0              2.0   \n",
       "27446         2019/6/24                 2  ...  0.0              4.0   \n",
       "27447          2019/5/9                 2  ...  0.0              2.0   \n",
       "27448         2019/5/14                 2  ...  1.0              1.0   \n",
       "27449         2019/6/23                 2  ...  0.0              2.0   \n",
       "27450         2019/5/23                 2  ...  0.0              2.0   \n",
       "27451               NaN                 2  ...  0.0              2.0   \n",
       "27452          2019/5/5                 3  ...  0.0              2.0   \n",
       "27453         2019/6/19                 1  ...  0.0              2.0   \n",
       "27454          2019/5/4                 1  ...  1.0              2.0   \n",
       "27455          2019/5/3                 2  ...  0.0              2.0   \n",
       "27456         2019/6/17                 2  ...  0.0              2.0   \n",
       "27457          2019/6/7                 3  ...  0.0              2.0   \n",
       "27458         2019/3/21                 2  ...  1.0              3.0   \n",
       "27459          2019/6/7                 2  ...  0.0              2.0   \n",
       "27460               NaN                 2  ...  0.0              2.0   \n",
       "27461               NaN                 1  ...  0.0              2.0   \n",
       "27462         2019/4/25                 1  ...  1.0              2.0   \n",
       "27463         2019/6/22                 3  ...  0.0              3.0   \n",
       "27464         2019/6/13                 4  ...  0.0              3.0   \n",
       "27465         2019/5/19                 1  ...  0.0              2.0   \n",
       "27466          2019/5/3                 1  ...  0.0              2.0   \n",
       "27467          2019/6/1                 2  ...  0.0              2.0   \n",
       "27468         2019/6/19                 2  ...  0.0              2.0   \n",
       "27469               NaN                 1  ...  0.0              2.0   \n",
       "\n",
       "      IS_MARRIED EDUCATIONDEGREE INDUSTRY_CATEGORY   CSP GRADUATION_DATE  \\\n",
       "0            3.0             1.0               3.0  中国电信          1982.0   \n",
       "1            3.0             4.0               4.0  中国电信          1994.0   \n",
       "2            3.0             1.0               3.0  中国电信          1996.0   \n",
       "3            3.0             2.0              15.0  中国电信          1995.0   \n",
       "4            3.0             3.0               6.0  中国电信          1997.0   \n",
       "5            3.0             2.0               6.0  中国电信          2005.0   \n",
       "6            3.0             2.0               3.0  中国电信          2017.0   \n",
       "7            3.0             2.0               7.0  中国电信          1991.0   \n",
       "8            3.0             2.0               8.0  中国电信          2008.0   \n",
       "9            1.0             4.0               3.0  中国电信          2017.0   \n",
       "10           2.0             1.0               3.0  中国电信          2003.0   \n",
       "11           1.0             2.0               3.0  中国电信          2017.0   \n",
       "12           3.0             2.0               6.0  中国电信          1992.0   \n",
       "13           3.0             1.0               5.0  中国电信          1988.0   \n",
       "14           3.0             2.0               6.0  中国电信          1998.0   \n",
       "15           2.0             3.0              16.0  中国电信          2003.0   \n",
       "16           3.0             1.0               3.0  中国电信          1998.0   \n",
       "17           3.0             2.0               7.0  中国电信          1993.0   \n",
       "18           3.0             2.0               6.0  中国电信          1988.0   \n",
       "19           3.0             1.0               3.0  中国电信          1987.0   \n",
       "20           3.0             1.0               3.0  中国电信          1999.0   \n",
       "21           3.0             3.0               3.0  中国电信          1994.0   \n",
       "22           3.0             3.0              11.0  中国电信          2002.0   \n",
       "23           3.0             2.0               3.0  中国电信          1988.0   \n",
       "24           3.0             1.0              12.0  中国电信          1985.0   \n",
       "25           3.0             2.0               3.0  中国电信          1995.0   \n",
       "26           3.0             2.0               3.0  中国电信          1989.0   \n",
       "27           3.0             3.0               5.0  中国电信          1986.0   \n",
       "28           3.0             1.0               3.0  中国电信          1992.0   \n",
       "29           3.0             3.0              16.0  中国电信          2004.0   \n",
       "...          ...             ...               ...   ...             ...   \n",
       "27440        3.0             2.0               6.0  中国电信          2017.0   \n",
       "27441        3.0             1.0               6.0  中国电信          1998.0   \n",
       "27442        3.0             2.0               9.0  中国电信          2017.0   \n",
       "27443        1.0             2.0               3.0  中国电信          2016.0   \n",
       "27444        3.0             1.0               7.0  中国电信          1996.0   \n",
       "27445        3.0             2.0               5.0  中国电信          2005.0   \n",
       "27446        3.0             2.0              16.0  中国电信          1997.0   \n",
       "27447        3.0             2.0               8.0  中国电信          2003.0   \n",
       "27448        3.0             2.0               3.0  中国电信          2009.0   \n",
       "27449        1.0             2.0               3.0  中国电信          2013.0   \n",
       "27450        3.0             2.0               8.0  中国电信          2007.0   \n",
       "27451        3.0             2.0               3.0  中国电信          2006.0   \n",
       "27452        3.0             3.0               3.0  中国电信          2015.0   \n",
       "27453        3.0             1.0               3.0  中国电信          1991.0   \n",
       "27454        3.0             1.0              15.0  中国电信          1993.0   \n",
       "27455        3.0             2.0               3.0  中国电信          2006.0   \n",
       "27456        3.0             2.0               6.0  中国电信          1999.0   \n",
       "27457        3.0             3.0               3.0  中国电信          2016.0   \n",
       "27458        3.0             2.0               7.0  中国电信          2001.0   \n",
       "27459        3.0             2.0               3.0  中国电信          1995.0   \n",
       "27460        3.0             2.0               3.0  中国电信          2005.0   \n",
       "27461        3.0             1.0               3.0  中国电信          2005.0   \n",
       "27462        3.0             1.0               8.0  中国电信          1989.0   \n",
       "27463        3.0             3.0               5.0  中国电信          1993.0   \n",
       "27464        1.0             4.0              16.0  中国电信          2017.0   \n",
       "27465        3.0             1.0               6.0  中国电信          1997.0   \n",
       "27466        3.0             1.0               3.0  中国电信          1986.0   \n",
       "27467        3.0             2.0               6.0  中国电信          1998.0   \n",
       "27468        3.0             2.0               3.0  中国电信          1988.0   \n",
       "27469        3.0             1.0               5.0  中国电信          2009.0   \n",
       "\n",
       "      D_DEBIT_BANK_NAME EMERGANCY_FIRST_RELATIONSHIP  \\\n",
       "0                江阴农商银行                          1.0   \n",
       "1                  农业银行                          3.0   \n",
       "2                  建设银行                          3.0   \n",
       "3                  建设银行                          1.0   \n",
       "4                  平安银行                          1.0   \n",
       "5                  中国银行                          3.0   \n",
       "6                  农业银行                          1.0   \n",
       "7                  邮储银行                          3.0   \n",
       "8                中国工商银行                          3.0   \n",
       "9                中国工商银行                          1.0   \n",
       "10                 邮储银行                          3.0   \n",
       "11             中国邮政储蓄银行                          0.0   \n",
       "12                 邮储银行                          1.0   \n",
       "13                 中国银行                          3.0   \n",
       "14                 农业银行                          1.0   \n",
       "15                 农业银行                          1.0   \n",
       "16                 工商银行                          0.0   \n",
       "17                 农业银行                          3.0   \n",
       "18                 中国银行                          1.0   \n",
       "19                 农业银行                          1.0   \n",
       "20                 邮储银行                          3.0   \n",
       "21                 建设银行                          1.0   \n",
       "22                 交通银行                          1.0   \n",
       "23                 中国银行                          1.0   \n",
       "24                 建设银行                          2.0   \n",
       "25                 交通银行                          1.0   \n",
       "26                 工商银行                          1.0   \n",
       "27                 建设银行                          1.0   \n",
       "28                 农业银行                          2.0   \n",
       "29                 建设银行                          1.0   \n",
       "...                 ...                          ...   \n",
       "27440              工商银行                          1.0   \n",
       "27441              工商银行                          3.0   \n",
       "27442              农业银行                          1.0   \n",
       "27443              农业银行                          3.0   \n",
       "27444              农业银行                          1.0   \n",
       "27445              建设银行                          1.0   \n",
       "27446              工商银行                          3.0   \n",
       "27447              中国银行                          1.0   \n",
       "27448              建设银行                          1.0   \n",
       "27449              邮储银行                          3.0   \n",
       "27450              工商银行                          0.0   \n",
       "27451              农业银行                          1.0   \n",
       "27452              工商银行                          1.0   \n",
       "27453              农业银行                          1.0   \n",
       "27454              农业银行                          1.0   \n",
       "27455              农业银行                          1.0   \n",
       "27456              农业银行                          1.0   \n",
       "27457              工商银行                          1.0   \n",
       "27458            中国农业银行                          3.0   \n",
       "27459              招商银行                          3.0   \n",
       "27460            中国农业银行                          1.0   \n",
       "27461              建设银行                          1.0   \n",
       "27462            中国农业银行                          3.0   \n",
       "27463              中国银行                          1.0   \n",
       "27464              建设银行                          3.0   \n",
       "27465              建设银行                          3.0   \n",
       "27466          中国邮政储蓄银行                          2.0   \n",
       "27467          东莞农村商业银行                          1.0   \n",
       "27468              中国银行                          3.0   \n",
       "27469            中国农业银行                          0.0   \n",
       "\n",
       "      EMERGANCY_SECOND_RELATIONSHIP  \n",
       "0                               4.0  \n",
       "1                               6.0  \n",
       "2                               6.0  \n",
       "3                               6.0  \n",
       "4                               6.0  \n",
       "5                               6.0  \n",
       "6                               6.0  \n",
       "7                               6.0  \n",
       "8                               6.0  \n",
       "9                               6.0  \n",
       "10                              6.0  \n",
       "11                              6.0  \n",
       "12                              6.0  \n",
       "13                              6.0  \n",
       "14                              6.0  \n",
       "15                              6.0  \n",
       "16                              4.0  \n",
       "17                              6.0  \n",
       "18                              6.0  \n",
       "19                              6.0  \n",
       "20                              6.0  \n",
       "21                              6.0  \n",
       "22                              6.0  \n",
       "23                              6.0  \n",
       "24                              6.0  \n",
       "25                              6.0  \n",
       "26                              6.0  \n",
       "27                              6.0  \n",
       "28                              6.0  \n",
       "29                              6.0  \n",
       "...                             ...  \n",
       "27440                           6.0  \n",
       "27441                           6.0  \n",
       "27442                           6.0  \n",
       "27443                           6.0  \n",
       "27444                           6.0  \n",
       "27445                           6.0  \n",
       "27446                           6.0  \n",
       "27447                           6.0  \n",
       "27448                           6.0  \n",
       "27449                           6.0  \n",
       "27450                           4.0  \n",
       "27451                           6.0  \n",
       "27452                           6.0  \n",
       "27453                           6.0  \n",
       "27454                           6.0  \n",
       "27455                           4.0  \n",
       "27456                           6.0  \n",
       "27457                           6.0  \n",
       "27458                           4.0  \n",
       "27459                           6.0  \n",
       "27460                           6.0  \n",
       "27461                           6.0  \n",
       "27462                           6.0  \n",
       "27463                           6.0  \n",
       "27464                           6.0  \n",
       "27465                           4.0  \n",
       "27466                           6.0  \n",
       "27467                           6.0  \n",
       "27468                           6.0  \n",
       "27469                           4.0  \n",
       "\n",
       "[27470 rows x 86 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import os\n",
    "os.chdir('D:\\迁移率')\n",
    "\n",
    "data = pd.read_csv('data.csv',low_memory=False)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-18T09:14:04.406449Z",
     "start_time": "2019-07-18T09:14:04.348603Z"
    }
   },
   "outputs": [],
   "source": [
    "df = pd.DataFrame(data, columns=['CUSTOMER_NAME','REQUEST_DATE']).copy()\n",
    "df.columns = ['name','date']\n",
    "df['date'] = pd.to_datetime(df['date'])\n",
    "df = df.set_index('date')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-07-18T09:17:38.607539Z",
     "start_time": "2019-07-18T09:17:38.574666Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2019-05-26 09:33:38</th>\n",
       "      <td>赵小球</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 16:27:56</th>\n",
       "      <td>秦爱梅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 18:24:43</th>\n",
       "      <td>杨芳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 20:56:15</th>\n",
       "      <td>肖敏学</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 12:45:31</th>\n",
       "      <td>陆云云</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 11:39:52</th>\n",
       "      <td>庞春易</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 14:36:02</th>\n",
       "      <td>何华涛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 17:17:39</th>\n",
       "      <td>杨彪武</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 17:28:04</th>\n",
       "      <td>冯宇媚</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 12:05:50</th>\n",
       "      <td>黎毅威</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 13:02:03</th>\n",
       "      <td>江俐敏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 12:32:00</th>\n",
       "      <td>陈秀英</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 16:36:23</th>\n",
       "      <td>肖志团</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 12:41:54</th>\n",
       "      <td>郭超</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 08:05:08</th>\n",
       "      <td>王传灿</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 10:39:07</th>\n",
       "      <td>华潮丽</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 14:55:21</th>\n",
       "      <td>潘娟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 09:29:04</th>\n",
       "      <td>张洪成</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 13:55:56</th>\n",
       "      <td>朱界旭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 10:56:51</th>\n",
       "      <td>王晓银</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 09:13:25</th>\n",
       "      <td>陈年军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 09:40:30</th>\n",
       "      <td>李福迁</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 14:04:56</th>\n",
       "      <td>许迎春</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 14:48:42</th>\n",
       "      <td>吴士超</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 14:03:05</th>\n",
       "      <td>程道德</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 15:44:35</th>\n",
       "      <td>于建洋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 10:39:54</th>\n",
       "      <td>冯旭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 14:29:09</th>\n",
       "      <td>荀跃芹</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 17:37:30</th>\n",
       "      <td>刘永华</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 12:06:15</th>\n",
       "      <td>杜芳英</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 16:43:58</th>\n",
       "      <td>张弟伟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 16:53:27</th>\n",
       "      <td>骆军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 15:01:01</th>\n",
       "      <td>张蓉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 13:55:26</th>\n",
       "      <td>冯思奎</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 19:31:33</th>\n",
       "      <td>陈志</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 10:22:41</th>\n",
       "      <td>宋洪涛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 14:21:55</th>\n",
       "      <td>焦源奎</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 15:16:12</th>\n",
       "      <td>覃祥果</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 16:22:54</th>\n",
       "      <td>曾文斐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 14:07:32</th>\n",
       "      <td>景松平</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 12:04:45</th>\n",
       "      <td>付朝辉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 12:14:59</th>\n",
       "      <td>徐雷</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 12:00:51</th>\n",
       "      <td>刘国飞</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 10:01:24</th>\n",
       "      <td>李天蓉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 18:25:27</th>\n",
       "      <td>李腊</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 17:46:11</th>\n",
       "      <td>李勇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 13:54:01</th>\n",
       "      <td>牛立波</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 21:41:29</th>\n",
       "      <td>叶慧娜</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 16:53:26</th>\n",
       "      <td>梁瑞玉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 19:50:56</th>\n",
       "      <td>吴万松</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 12:43:36</th>\n",
       "      <td>彭广州</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 15:30:09</th>\n",
       "      <td>沈飞琴</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 14:00:27</th>\n",
       "      <td>何晓林</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 16:00:38</th>\n",
       "      <td>范一帆</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 16:48:43</th>\n",
       "      <td>李敏昌</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 20:14:55</th>\n",
       "      <td>赵永杰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 17:49:01</th>\n",
       "      <td>刘本俊</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 11:46:55</th>\n",
       "      <td>李华山</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 13:47:24</th>\n",
       "      <td>谢毅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019-05-26 15:50:50</th>\n",
       "      <td>唐健</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>360 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    name\n",
       "date                    \n",
       "2019-05-26 09:33:38  赵小球\n",
       "2019-05-26 16:27:56  秦爱梅\n",
       "2019-05-26 18:24:43   杨芳\n",
       "2019-05-26 20:56:15  肖敏学\n",
       "2019-05-26 12:45:31  陆云云\n",
       "2019-05-26 11:39:52  庞春易\n",
       "2019-05-26 14:36:02  何华涛\n",
       "2019-05-26 17:17:39  杨彪武\n",
       "2019-05-26 17:28:04  冯宇媚\n",
       "2019-05-26 12:05:50  黎毅威\n",
       "2019-05-26 13:02:03  江俐敏\n",
       "2019-05-26 12:32:00  陈秀英\n",
       "2019-05-26 16:36:23  肖志团\n",
       "2019-05-26 12:41:54   郭超\n",
       "2019-05-26 08:05:08  王传灿\n",
       "2019-05-26 10:39:07  华潮丽\n",
       "2019-05-26 14:55:21   潘娟\n",
       "2019-05-26 09:29:04  张洪成\n",
       "2019-05-26 13:55:56  朱界旭\n",
       "2019-05-26 10:56:51  王晓银\n",
       "2019-05-26 09:13:25  陈年军\n",
       "2019-05-26 09:40:30  李福迁\n",
       "2019-05-26 14:04:56  许迎春\n",
       "2019-05-26 14:48:42  吴士超\n",
       "2019-05-26 14:03:05  程道德\n",
       "2019-05-26 15:44:35  于建洋\n",
       "2019-05-26 10:39:54   冯旭\n",
       "2019-05-26 14:29:09  荀跃芹\n",
       "2019-05-26 17:37:30  刘永华\n",
       "2019-05-26 12:06:15  杜芳英\n",
       "...                  ...\n",
       "2019-05-26 16:43:58  张弟伟\n",
       "2019-05-26 16:53:27   骆军\n",
       "2019-05-26 15:01:01   张蓉\n",
       "2019-05-26 13:55:26  冯思奎\n",
       "2019-05-26 19:31:33   陈志\n",
       "2019-05-26 10:22:41  宋洪涛\n",
       "2019-05-26 14:21:55  焦源奎\n",
       "2019-05-26 15:16:12  覃祥果\n",
       "2019-05-26 16:22:54  曾文斐\n",
       "2019-05-26 14:07:32  景松平\n",
       "2019-05-26 12:04:45  付朝辉\n",
       "2019-05-26 12:14:59   徐雷\n",
       "2019-05-26 12:00:51  刘国飞\n",
       "2019-05-26 10:01:24  李天蓉\n",
       "2019-05-26 18:25:27   李腊\n",
       "2019-05-26 17:46:11   李勇\n",
       "2019-05-26 13:54:01  牛立波\n",
       "2019-05-26 21:41:29  叶慧娜\n",
       "2019-05-26 16:53:26  梁瑞玉\n",
       "2019-05-26 19:50:56  吴万松\n",
       "2019-05-26 12:43:36  彭广州\n",
       "2019-05-26 15:30:09  沈飞琴\n",
       "2019-05-26 14:00:27  何晓林\n",
       "2019-05-26 16:00:38  范一帆\n",
       "2019-05-26 16:48:43  李敏昌\n",
       "2019-05-26 20:14:55  赵永杰\n",
       "2019-05-26 17:49:01  刘本俊\n",
       "2019-05-26 11:46:55  李华山\n",
       "2019-05-26 13:47:24   谢毅\n",
       "2019-05-26 15:50:50   唐健\n",
       "\n",
       "[360 rows x 1 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s = pd.Series(df['name'],index=df.index)\n",
    "df['2019-05-26']"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
